UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R06i8k5J+5JXJX4Ou48M2mmLAOMHcMTkHd9TB/vjzNg='
WHERE
key_id = 'ffa393d1ebf1c9e17124d5a576d6612e27574e90ae1eb542fab1d1adf93f3a9b'
AND (
token = 'R06i8k5J+5JXJX4Ou48M2mmLAOMHcMTkHd9TB/vjzNg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)