UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7rEmmvvSGeFm9K82qiUqTwHKF3FFA4xfyC6dofjRehI='
WHERE
key_id = '46a6c4ed0370c0a70370d0bfac0dd3e1cb35a5a675810c5ccc1253f122e4fee6'
AND (
token = '7rEmmvvSGeFm9K82qiUqTwHKF3FFA4xfyC6dofjRehI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)