UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BVm4wDV8H4iyU/MDERkwwFtO4M81oiWiQykty9PwMM8='
WHERE
key_id = '065aa708f50a60238814f3613414b05495d77732fc1a3ba080819dec22ec6c49'
AND (
token = 'BVm4wDV8H4iyU/MDERkwwFtO4M81oiWiQykty9PwMM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)