UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o6fyrO9kA7a8/ug0yjyOMwwS9hLEbRmFVRkzAJbKP78='
WHERE
key_id = 'e22f5cb72cb6696d2b0dfabd0616c31130891a5721c37c57566a56f2acd707cf'
AND (
token = 'o6fyrO9kA7a8/ug0yjyOMwwS9hLEbRmFVRkzAJbKP78='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)