UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mXNoo1SxGxYsft/eTVDPc9JPmC5JzJs4Df9OxlZ3noA='
WHERE
key_id = '9393d86174087d5a954034ae8a9dfb6c26ee401bb97e063d22a1fdb239a4f295'
AND (
token = 'mXNoo1SxGxYsft/eTVDPc9JPmC5JzJs4Df9OxlZ3noA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)