UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5ymyQRNuxVpvKyp3F0soVx+ZvHDYc0aTMhacL4GonWg='
WHERE
key_id = 'e06ab5ca14bf0dca2cd31b83b564d4b7b73c6840de7a0be8b008376e589b3cda'
AND (
token = '5ymyQRNuxVpvKyp3F0soVx+ZvHDYc0aTMhacL4GonWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)