UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DI/d78ipc8ygtN2pUppTTywPWSHZzxTlhybHnV8OCb0=' 
WHERE 
  key_id = '1b49bd9e40d63d5667feef218d9bf795d9bec1eff89e8f7f2979ae7b41bf4c11' 
  AND (
    token = 'DI/d78ipc8ygtN2pUppTTywPWSHZzxTlhybHnV8OCb0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00049