UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rEQn2X6p++gGMaCL7pGJcmM3/kl1ejl4611CUku5HhI=' 
WHERE 
  key_id = '3b6cfa7c5db13309394c32123982614f575c0da9959fa2a2f398d0daa60c7d01' 
  AND (
    token = 'rEQn2X6p++gGMaCL7pGJcmM3/kl1ejl4611CUku5HhI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00046