UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xCVl0X8myymX9vGYslJpJGUAgDaV3E8/We8/oYaMbP4='
WHERE
key_id = '6f138769731367ad88f8d9b6c6958319a6ce5f05f3951790c648cb8202126dad'
AND (
token = 'xCVl0X8myymX9vGYslJpJGUAgDaV3E8/We8/oYaMbP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)