UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cexn5SAaJV3EJ6IeBwfUnjVM1z97xrAGqhoTSUNt2b0='
WHERE
key_id = '0c7c663a61c04653e69bdab9be0e35cfc7064152456403b5cc28820eb3c04a77'
AND (
token = 'cexn5SAaJV3EJ6IeBwfUnjVM1z97xrAGqhoTSUNt2b0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)