UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JsBT7A7LxhjqXzqameH8INAntHW14nJSAjV9a7sRaWU='
WHERE
key_id = 'a5f9a4a3c354b90d21c58eff3890d3e080985bf366f59e940d5276a5d1629ace'
AND (
token = 'JsBT7A7LxhjqXzqameH8INAntHW14nJSAjV9a7sRaWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)