UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DEGOAYmpUZ+QJbF0B5tKOpdW8K5vfaTiOXj48wrKP0g=' 
WHERE 
  key_id = 'e1147ffef367db8d065fb1cb53ecf9728d353f869b6ba79b4f2a0e032376759c' 
  AND (
    token = 'DEGOAYmpUZ+QJbF0B5tKOpdW8K5vfaTiOXj48wrKP0g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025