UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2KHrDjZN0a5ejQOiNO0/0HKBH8Qvsup2W/gnCi72vmg='
WHERE
key_id = '1b5ccb164842ee5bb645300da93c770a830241fb51bb0f5c1043d2a4c949136b'
AND (
token = '2KHrDjZN0a5ejQOiNO0/0HKBH8Qvsup2W/gnCi72vmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)