UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'L4bdmLim2RYXaiE6ll/ivIVZeGf2sYwV91IEjtlchv8=' 
WHERE 
  key_id = 'c7d9544d6919589802f813bc4142a27b631c9c4ad70b316667c0f5901475fdcb' 
  AND (
    token = 'L4bdmLim2RYXaiE6ll/ivIVZeGf2sYwV91IEjtlchv8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018