UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1jUBm4r+pZ7nzdyC8S3ApjLH6v7H5rTWn5z7jrfy2Ik='
WHERE
key_id = '7f2d7e2133ec8f6fcbc4d25e67f9c23a2924cf597b03058e6c54e2235302fec1'
AND (
token = '1jUBm4r+pZ7nzdyC8S3ApjLH6v7H5rTWn5z7jrfy2Ik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)