UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1c6yBLh45aryXk3jsgaXTj8X5YgTXzOVPPK9grg1HNA='
WHERE
key_id = '504a6e173ce966e73d486e2341f37e3b3ebf46c78c0afdf37bd1930abfbe2b07'
AND (
token = '1c6yBLh45aryXk3jsgaXTj8X5YgTXzOVPPK9grg1HNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)