UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aQ9FjsjQhaO6iEVmW6/2E16R5znhXxr5GedG0WcumqY='
WHERE
key_id = '8fdce608a8a18e7fdaecc5561c5dd7eeada4357894d5464246f868e242951a63'
AND (
token = 'aQ9FjsjQhaO6iEVmW6/2E16R5znhXxr5GedG0WcumqY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)