UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'yfZKeuzJ+N6iH+6MFUOx8Vr8haP4D2lQU3btWbp7Tz0=' 
WHERE 
  key_id = 'e2cb88f3649e4e91d9cd61cbf2ace3498a79650a4be951d7d6761a2701cd6600' 
  AND (
    token = 'yfZKeuzJ+N6iH+6MFUOx8Vr8haP4D2lQU3btWbp7Tz0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030