UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iN5N50ofmUMECDdbDURsKaZKCX5qY66NjFHH5QGQwm8='
WHERE
key_id = '80eeccc00f9e94e37052b8172550b11f329d22d81c83137bab391d6c0434a9a4'
AND (
token = 'iN5N50ofmUMECDdbDURsKaZKCX5qY66NjFHH5QGQwm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)