UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XBTdmQGvrsR0JGkzBUJQGTvXJjnCFqW23lybZZqtwiE='
WHERE
key_id = '110fc5e6fe232c120056188a1ba9dba929ac1a5556a9f7f3421955d3234a4a77'
AND (
token = 'XBTdmQGvrsR0JGkzBUJQGTvXJjnCFqW23lybZZqtwiE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)