UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tPPjJEXhssZ+100endAoPPeXG07/mSYy8YTceCe9Nv8='
WHERE
key_id = 'dabfc0ae38a79d772cc9d24c8fff3fbed84bae2b1add2461aa9ae8422b260aeb'
AND (
token = 'tPPjJEXhssZ+100endAoPPeXG07/mSYy8YTceCe9Nv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)