UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nzs88kfhAkf2Z83ZHd6ZiLEqIaxcNJyJBiIcKlzzT1g='
WHERE
key_id = '047ac8c39f0ef87a4dca465c782a0882223c81447dcc2e05147e1f55cc839d28'
AND (
token = 'nzs88kfhAkf2Z83ZHd6ZiLEqIaxcNJyJBiIcKlzzT1g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)