UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HIVwcx1Z4ujIiofnvDoQleapPGtY2x17BRTK0hI6TRE='
WHERE
key_id = '477e0d123db52eef387c800fd0da17c55a1227ec842fac0be287b9bf7e355266'
AND (
token = 'HIVwcx1Z4ujIiofnvDoQleapPGtY2x17BRTK0hI6TRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)