UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BOqWsgfkYSg1pNneu/2aeL2rBdPB/9EysjwefmW4+KI='
WHERE
key_id = 'f4be3315122e083cf9d57620a76100ca637d172f5bb70fa3bbd840ebca560b68'
AND (
token = 'BOqWsgfkYSg1pNneu/2aeL2rBdPB/9EysjwefmW4+KI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)