UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YSaf7tQihGMKNBwWRtbAr8LR3nqvFwSZa0iRd7V6fog='
WHERE
key_id = 'f5b5972380bf056b4fd06a9f0b7fe6eee4feffb5bb212022a7288aae666ece96'
AND (
token = 'YSaf7tQihGMKNBwWRtbAr8LR3nqvFwSZa0iRd7V6fog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)