UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/+3lQvPLx1w0aMK8l7JSipDSwles0SkdwVSRkrVlLU4=' 
WHERE 
  key_id = '7707ab1566c4475db63523a35509019926554b6b2adc0397ef7f7e557f6fcd9a' 
  AND (
    token = '/+3lQvPLx1w0aMK8l7JSipDSwles0SkdwVSRkrVlLU4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028