UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gTt34Fe75XTi09fv0gkzPVO8nTYvAIktZpPprxEHZo='
WHERE
key_id = '9bf1cf626a58a35d19493f1ab8db57a84f5dcace55f84ed505e7e1741c007893'
AND (
token = '6gTt34Fe75XTi09fv0gkzPVO8nTYvAIktZpPprxEHZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)