UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hXRDhPZVYlGasEgR4ub3DBCk398+cCoHMTPz8oOW/MQ='
WHERE
key_id = '99b141588103db4456ac51f9c9f27270690d9324b36da9c9759617384b1fc633'
AND (
token = 'hXRDhPZVYlGasEgR4ub3DBCk398+cCoHMTPz8oOW/MQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)