UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd/gF4yyIos1zJgv3Aw4vcVcjw54sKL/JFcTgtuBoYrU='
WHERE
key_id = '000c544030eff57c57e4c09943301e0f5dee23f4ec4990c1ff4b0bbbdc789a08'
AND (
token = 'd/gF4yyIos1zJgv3Aw4vcVcjw54sKL/JFcTgtuBoYrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)