UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R9Qd+S7c4xuJTzHbexl3REQCfAcyOtd+rkgWO9ewdrQ='
WHERE
key_id = '712596ddf5b1df3e262bc7aea45a9662da9354cb7557e08265320419af3f997a'
AND (
token = 'R9Qd+S7c4xuJTzHbexl3REQCfAcyOtd+rkgWO9ewdrQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)