UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '1Io5cP49PBg0pTQfv8sAglzkF/HeI3Jxa2SsjlPnB+Q=' 
WHERE 
  key_id = '87012e46a83bb1f92094ff254d1034bcc216f15c573356f236df3ecb44509ef8' 
  AND (
    token = '1Io5cP49PBg0pTQfv8sAglzkF/HeI3Jxa2SsjlPnB+Q=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028