UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3L0JWf4aHZ29uICwqAv7aJ9BtGfI9I2xn2Gys6XikKY='
WHERE
key_id = '271db0a995e168328c7aa659fca9b653a18d26c9647a9e6e2948bf521fc5e09c'
AND (
token = '3L0JWf4aHZ29uICwqAv7aJ9BtGfI9I2xn2Gys6XikKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)