UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CE9RlnL6eZWI23+PpY3lGTCYW4Stm9YfRCzLrq918yk='
WHERE
key_id = 'c012102429ae183e3110fba0b03626aa15f0e2069c6d41cdf6220ddd883481ff'
AND (
token = 'CE9RlnL6eZWI23+PpY3lGTCYW4Stm9YfRCzLrq918yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)