UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'acQ6vivUt5eblHM5MEXXfKZjTMIfFbNxFI1MIGF7kWM='
WHERE
key_id = '31ab1f5e3df03a816530e2b0e68b5d68960b69f28cacf35d45e674adb29d8ff1'
AND (
token = 'acQ6vivUt5eblHM5MEXXfKZjTMIfFbNxFI1MIGF7kWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)